CREATE TABLE [dbo].[PatientActivation]
(
[TransactionId] [nchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PatientCode] [nchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FirstName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateOfBirth] [datetime] NULL,
[Phone] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sex] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MemberType] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MembershipSOSNumber] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MembershipSOSExpDate] [datetime] NULL,
[InsuranceCardNumber] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InsuranceCardExpDate] [datetime] NULL,
[CompanyCode] [nchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CompanyName] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Nationality] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApptRemark] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApptStatus] [nvarchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApptNote] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remark] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsComplete] [bit] NOT NULL CONSTRAINT [DF_PatientActivation_IsComplete] DEFAULT ((0)),
[CreateUser] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_PatientActivation_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
ALTER TABLE [dbo].[PatientActivation] ADD 
CONSTRAINT [PK_PatientActivation] PRIMARY KEY CLUSTERED  ([TransactionId]) ON [PRIMARY]
GO
